package cn.yunhe.dao;

import cn.yunhe.entity.Traveller;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;
@Mapper
public interface TravellerDao {
    @Select("select  * from traveller")
    List<Traveller> findAll();

    @Select("select * from traveller t,order_traveller ot where t.id=ot.travellerId and ot.orderId= #{id}")
    List<Traveller> SelectById(Integer id);

}
